<?php
	/*-----------------------------------------------------------------------
	Name         : report.php
	Version      : 1.2-PHP5
	Description  : Retrieve payment information, when triggerd by Zaypay
	Date         : June 2009, Amsterdam, The Netherlands
	By           : Zaypay International B.V. 2008 - 2009 (RDF)
	Last changes : Made class easier to use and understand
	-----------------------------------------------------------------------*/
	require_once('includes/config.php');
	require_once('includes/Zaypay.class.php');
	require_once('includes/database.php');
	$Zaypay = New Zaypay($price_setting_id, $price_setting_key);
	if (isset($_GET['payment_id']))
	{
		$zaypay_info    = $Zaypay->show_payment($_GET['payment_id']);
		$payment_id     = $zaypay_info['payment']['id'];
		$payment_status = $zaypay_info['payment']['status'];
		// Get the ID
		$result = mysql_query("SELECT * FROM zaypay_payment WHERE payID='{$payment_id}' LIMIT 1");
		$array = mysql_fetch_assoc($result);
		 // Get current amount of points
		$pp = mysql_query("SELECT premium_points FROM accounts WHERE accounts.id = '{$array['account_id']}'");
		$points = mysql_fetch_assoc($pp);
		$point = $points["premium_points"] + $points_to_give;
		// Update to new status in database
		mysql_query("UPDATE zaypay_payment SET status = '{$payment_status}' WHERE payID = '{$payment_id}'");
		// Only give points if the status is "paid"
		if ($payment_status == "paid" && $array["status"] != "paid")
		{
			// Update points in account table
			mysql_query("UPDATE accounts SET premium_points = '$point' WHERE accounts.id = '{$array['account_id']}'");
			mysql_query("INSERT INTO `z_shop_points_bought` (`id`, `amount`, `type`, `accountid`, `code`, `paypalmail`, `date`) VALUES (NULL , '".$points_to_give."', 'Zaypay', '".$array['account_id']."', '".$payment_id."', 'N/A',CURRENT_TIMESTAMP);"); 
		}
	}
	die ('*ok*');
?>
